USE [family-annal]
GO
-- tao em trai
INSERT INTO dbo.tb_fa_master_data
( master_data_key, master_data_code, master_data_type_1, master_data_type_2, master_data_type_3
, master_data_name, master_data_value_num, master_data_value_datetime
, master_data_value_string, master_data_description, master_data_status)
VALUES
-- key XUNG HO, code cach XUNG HO CHUAN, N: la quan he ben ve phai (la em) Y: la quan he ben ve trai (la anh/chi), gioi tinh Y: male N: female, thu tu doi 
( 'XUNG_HO', 'STANDARD', 'N', 'Y', 0
-- name, value kieu so, value kieu datetime
, 'cach xung ho trong anh em', null, null
-- value kieu chuoi, description, trang thai hoat dong Y: active N: inactive
, 'em trai', 'cach xung ho anh chi em', 'Y');
GO
-- tao em gai
INSERT INTO dbo.tb_fa_master_data
( master_data_key, master_data_code, master_data_type_1, master_data_type_2, master_data_type_3
, master_data_name, master_data_value_num, master_data_value_datetime
, master_data_value_string, master_data_description, master_data_status)
VALUES
-- key XUNG HO, code cach XUNG HO CHUAN, N: la quan he ben ve phai (la em) Y: la quan he ben ve trai (la anh/chi), gioi tinh Y: male N: female, thu tu doi 
( 'XUNG_HO', 'STANDARD', 'N', 'N', 0
-- name, value kieu so, value kieu datetime
, 'cach xung ho trong anh em', null, null
-- value kieu chuoi, description, trang thai hoat dong Y: active N: inactive
, 'em gai', 'cach xung ho anh chi em', 'Y');
GO
-- tao chi gai
INSERT INTO dbo.tb_fa_master_data
( master_data_key, master_data_code, master_data_type_1, master_data_type_2, master_data_type_3
, master_data_name, master_data_value_num, master_data_value_datetime
, master_data_value_string, master_data_description, master_data_status)
VALUES
-- key XUNG HO, code cach XUNG HO CHUAN, N: la quan he ben ve phai (la em) Y: la quan he ben ve trai (la anh/chi), gioi tinh Y: male N: female, thu tu doi 
( 'XUNG_HO', 'STANDARD', 'Y', 'N', 0
-- name, value kieu so, value kieu datetime
, 'cach xung ho trong anh em', null, null
-- value kieu chuoi, description, trang thai hoat dong Y: active N: inactive
, 'chi', 'cach xung ho anh chi em', 'Y');
GO
-- tao anh trai
INSERT INTO dbo.tb_fa_master_data
( master_data_key, master_data_code, master_data_type_1, master_data_type_2, master_data_type_3
, master_data_name, master_data_value_num, master_data_value_datetime
, master_data_value_string, master_data_description, master_data_status)
VALUES
-- key XUNG HO, code cach XUNG HO CHUAN, N: la quan he ben ve phai (la em) Y: la quan he ben ve trai (la anh/chi), gioi tinh Y: male N: female, thu tu doi 
( 'XUNG_HO', 'STANDARD', 'Y', 'Y', 0
-- name, value kieu so, value kieu datetime
, 'cach xung ho trong anh em', null, null
-- value kieu chuoi, description, trang thai hoat dong Y: active N: inactive
, 'anh', 'cach xung ho anh chi em', 'Y');
